-- Drop the views
DROP VIEW IF EXISTS alter_v1;
GO

DROP VIEW IF EXISTS guest.alter_v1;
GO

DROP VIEW IF EXISTS alter_v2;
GO

DROP VIEW IF EXISTS alter_v3;
GO

DROP VIEW IF EXISTS alter_v4;
GO

DROP VIEW IF EXISTS alter_v5;
GO

DROP VIEW IF EXISTS alter_v6;
GO

DROP VIEW IF EXISTS alter_v7;
GO

DROP VIEW IF EXISTS alter_v8;
GO

DROP VIEW IF EXISTS alter_v9;
GO

DROP VIEW IF EXISTS alter_v10;
GO

DROP VIEW IF EXISTS alter_v11;
GO

DROP VIEW IF EXISTS alter_v12;
GO

DROP VIEW IF EXISTS alter_v13;
GO

DROP VIEW IF EXISTS alter_v14;
GO

DROP VIEW IF EXISTS alter_v15;
GO

DROP VIEW IF EXISTS alter_v16;
GO

DROP VIEW IF EXISTS alter_v17;
GO

DROP VIEW IF EXISTS alter_v18;
GO

DROP VIEW IF EXISTS alter_v19;
GO

DROP VIEW IF EXISTS alter_v20;
GO

DROP VIEW IF EXISTS alter_v21;
GO

DROP VIEW IF EXISTS alter_v22;
GO

DROP VIEW IF EXISTS alter_v23;
GO

DROP VIEW IF EXISTS guest.alter_v1;
GO

DROP VIEW IF EXISTS alter_v25;
GO

DROP VIEW IF EXISTS alter_v24;
GO

DROP VIEW IF EXISTS alter_v26;
GO

-- Drop the tables
DROP TABLE IF EXISTS alter_t;
GO

DROP TABLE IF EXISTS alter_t1;
GO

DROP TABLE IF EXISTS alter_t2;
GO

DROP TABLE IF EXISTS alter_t3;
GO

DROP TABLE IF EXISTS alter_t4;
GO